| |
4979 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 27 September 2023 16:26 «»
By: Duane
Inserted JSON into Column is being Truncated
…00,"user":{"id":63,"username":"eburras1q"}},{"id":2,"body":"What terrific math skills you’re showing!","postId":27,"user":{"id":71,"username":&…
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 28 September 2023 11:33 «»
By: Barbara Boehmer
Re: Inserted JSON into Column is being Truncated
…,"user"
:{"id":63,"username":"eburras1q"}},{"id":2,"body":"What terrific math skills you
’re showing!","postId":27,"user":{"id":71,"username":&…
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 28 September 2023 01:00 «»
By: Barbara Boehmer
Re: Inserted JSON into Column is being Truncated
…,"user"
:{"id":63,"username":"eburras1q"}},{"id":2,"body":"What terrific math skills you
’re showing!","postId":27,"user":{"id":71,"username":&…
|
| 4 |
Forum: Security «»
Posted on: Sun, 14 August 2022 05:57 «»
By: Andrey_R
ORA-01017: invalid username/password
…> conn test/1
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL>
SYS does connect OK
SQL>
SQL> conn sys as sysdba
Enter password:
Connected.
SQL>
SQLNET.ORA has…
|
| 5 |
Forum: Data Guard «»
Posted on: Thu, 28 September 2023 13:30 «»
By: LIPEKA
Re: RMAN-00554 RMAN-04006
…reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 4865390248 bytes
Fixed …
|
| 6 |
Forum: Client Tools «»
Posted on: Sun, 23 July 2023 12:07 «»
By: John Watson
Re: problems with servers (tns:protocol adapter error)
…t;oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause: An invalid username or password was entered in an
// attempt to…
|
| 7 |
Forum: Forms «»
Posted on: Tue, 29 August 2023 04:24 «»
By: mfahimaamirgmailcom
Re: Enable\Disable menu items for different users
…bsp;argument 1 to builtin
DECLARE
USERNAME VARCHAR2(40);
BEGIN
USERNAME := Get_Application_Property(USERNAME);
SET_MENU_ITEM_PROPERTY('MANUMENUWINDOW.TEST1',ENABLED,PROPERTY_FALSE);
END;
DECLARE
USERNAME VARCHAR2(40);
BEGIN…
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 April 2024 11:20 «»
By: Michel Cadot
Re: Convert input from user into UPPERCASE
…case, Oracle will do it:
SQL> select username from all_users where username='TEST123';
no rows selected
SQL> create user test123 identified by "test123";
User created.
SQL> select username from all_users where username='…
|
| 9 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 April 2024 10:52 «»
By: Barbara Boehmer
Re: Convert input from user into UPPERCASE
…2.1.0.2.0> ACCEPT muser CHAR PROMPT 'Give username :'
Give username :Test123
SCOTT@orcl_12.1.0.2.0> SELECT UPPER('&&muser') AS muser FROM DUAL
2 /
1 row selected.
SCOTT@orcl_12.1.0.2.0> CREATE USER "&…
|
| 10 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 April 2024 10:35 «»
By: Barbara Boehmer
Re: Convert input from user into UPPERCASE
…2.1.0.2.0> ACCEPT muser CHAR PROMPT 'Give username :'
Give username :Test123
SCOTT@orcl_12.1.0.2.0> DECLARE
2 v_user VARCHAR2(10) := UPPER('&&muser');
3 BEGIN
4 …
|
| 11 |
Forum: Server Administration «»
Posted on: Thu, 10 November 2022 01:24 «»
By: jesuisantony
Proxy PDB Connection Fails with Password Error
…--------------
ORAPDB_PROXY
SQL> select username from dba_users where username='TEST';
USERNAME
------------------------------
TEST
SQL>
When connecting to reference PDB it just says
Enter user-name: test/test@ORAPDB
ERROR:
ORA-01017…
|
| 12 |
Forum: Security «»
Posted on: Sun, 14 August 2022 07:32 «»
By: Andrey_R
Re: ORA-01017: invalid username/password
…st/"a"
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> conn test/a
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn test/A
ERROR:
ORA-01017…
|
| 13 |
Forum: Forms «»
Posted on: Thu, 31 August 2023 05:16 «»
By: mfahimaamirgmailcom
Menu roles table: how to create and use it
…code in startup code
declare
l_username varchar2(40);
begin
l_username := get_application_property(username);
SET_MENU_ITEM_PROPERTY('MANUMENUWINDOW.TEST1',ENABLED,PROPERTY_FALSE);
end;
Dear Sir, I followed this code, but the …
|
| 14 |
Forum: Forms «»
Posted on: Thu, 31 August 2023 00:20 «»
By: mfahimaamirgmailcom
Re: Enable\Disable menu items for different users
…my code in startup code
declare
l_username varchar2(40);
begin
l_username := get_application_property(username);
SET_MENU_ITEM_PROPERTY('MANUMENUWINDOW.TEST1',ENABLED,PROPERTY_FALSE);
end;
sir see attached picture
Could you please …
|
| 15 |
Forum: Forms «»
Posted on: Tue, 29 August 2023 05:27 «»
By: Littlefoot
Re: Enable\Disable menu items for different users
…, it was as if you wrote GET_APPLICATION_PROPERTY(NULL) and that's invalid. Try something like
declare
l_username varchar2(40);
begin
l_username := get_application_property(username);
-- the rest of your code goes here
end…
|
| 16 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Tue, 06 June 2023 07:42 «»
By: ahmedelsadr
Re: Moving From EBS to Fusion - main differences
…ion, for example ON fusion supplier can have username and password and access your fusion, and see their financial statements and entering their invoices themselves, the same for customer portal who are now can get direct access to see their statements…
|
| 17 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 03 April 2024 08:58 «»
By: Barbara Boehmer
Re: Implement Profile, PW Policy & Roles
… to determine if you already have such a thing:
select username from dba_users where username = 'DBSEC';
My best guess is that DBSEC is an abbreviation for database security.
You may find that you have it, but the account needs to be unlocked…
|
| 18 |
Forum: Forms «»
Posted on: Tue, 05 December 2023 04:07 «»
By: Littlefoot
Re: ON-LOGON trigger not working (merged)
… (plus additional optional) parameters:
- username: any valid username of up to 80 characters
- password: any valid password of up to 80 characters, including a database connect string
which means that you used it properly. Documentation example …
|
| 19 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Fri, 10 February 2023 09:43 «»
By: ccpCCP88
XDOLoader error for eTEXT template download
…acle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD devapps -JDBC_CONNECTION "devcgffinapp01.xx.com:PORT=1521:prod" -LOB_TYPEDATA_TEMPLATE -APPS_SHORT_NAME "oks" -LOB_CODE <lob_code> -LANGUAGE us -TERRITORY GB…
|
| 20 |
Forum: Security «»
Posted on: Tue, 27 September 2022 09:17 «»
By: evoradba
how to retrieve user logging 120 days ago
… days ago, is this possible?
SELECT c.username,
a.SAMPLE_TIME,
a.SQL_EXEC_START,
b.SQL_TEXT
FROM DBA_HIST_ACTIVE_SESS_HISTORY a, dba_hist_sqltext b, dba_users c
WHERE a.SQL_ID = b.SQL_ID(+)
AND a.user_id…
|
| 21 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 28 June 2022 15:43 «»
By: Michel Cadot
Re: BASIC SYNTAX
…
"username" is either an schema name if the database is local, or username@tnsalias if the database is remote.
If the database is local, you must set the environment variable ORACLE_SID to the database name and ORACLE_HOME to the directory …
|
| 22 |
Forum: Server Administration «»
Posted on: Tue, 24 May 2022 04:08 «»
By: shamsad.khan@gmail.com
Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0
…cl, got error message*
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE
Again logged in through sqlplus and did the below job
alter session set container=orclpdb;
alter pluggable database …
|
| 23 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 27 January 2002 10:17 «»
By: Suresh Vemulapalli
Re: oracle osuser name
there is one more way...
select sid,serial#,username,osuser
from v$session
where username=USER
and osuser=sys_context('USERENV','OS_USER')
|
| 24 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 24 January 2002 21:01 «»
By: Amita Kapadia
oracle osuser name
…I connect to oracle db. I want to know osuser because oracle user name is used by many users. so I cannot say select username,osuser from v$session where username like 'abc' and osuser = ?. so session id or osuser name is required to use in trigger…
|
| 25 |
Forum: Community Hangout «»
Posted on: Tue, 21 May 2024 13:30 «»
By: Littlefoot
Re: MICROWAVE WOES
… an option (here) ; I chose the "Forgot username" which asks for recovery phone number (and email address, which would be your Hotmail or - if you're willing to try it - Gmail).
That's really frustrating. I sincerely hope you'll manage to …
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 14 May 2024 11:52 «»
By: Barbara Boehmer
Re: Get the MetaData for FGA Policy
… ( username, when, query)
VALUES
( USER, SYSTIMESTAMP, SYS_CONTEXT ('USERENV', 'CURRENT_SQL'));
COMMIT…
|
| 27 |
Forum: Security «»
Posted on: Fri, 26 April 2024 09:06 «»
By: dom606_user
Re: Unlocking Oracle 9i SYS user
…solution?
SQL> select account_status from dba_users where username = 'SYS';
ACCOUNT_STATUS
--------------------------------
LOCKED
conn as sysdba
Enter user-name: sys/manager@XE as sysdba
ERROR:
ORA-28000: The account is locked.
BR…
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 April 2024 10:02 «»
By: watisditnou@msn.com
Convert input from user into UPPERCASE
…RCHAR2(10)
ACCEPT muser CHAR PROMPT 'Give username :'
CREATE USER "&&muser" PROFILE "WORK" IDENTIFIED BY "Test123" PASSWORD EXPIRE DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" …
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 17 March 2024 12:59 «»
By: Littlefoot
Re: Do users ever create tables in these schemas?
…it?
The simplest option is to provide username/password combination. If you (presuming you're a DBA) don't share that info with anyone, no problem.
Another option is to grant privileges (e.g. CREATE ANY TABLE) which will let that particular user …
|
| 30 |
Forum: Suggestions & Feedback «»
Posted on: Wed, 08 November 2023 10:12 «»
By: Barbara Boehmer
Re: Login issue
… prompted me to login again, so I entered my username and password and logged in, without encountering anything that asked me to change my password. I suppose my logging out using Firefox may have caused the website to consider me logged out, even …
|
| 31 |
Forum: Suggestions & Feedback «»
Posted on: Wed, 08 November 2023 00:04 «»
By: Littlefoot
Login issue
…I'm not redirected to page which requires my username/password combination, but page which asks me to change password (?!?). I just click the "Update" button, without modifying anything on that page. And here I am, logged in.
Is that expected…
|
| 32 |
Forum: Security «»
Posted on: Fri, 27 October 2023 10:44 «»
By: Michel Cadot
Re: ORA-01031 permission denied
…e: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a …
|
| 33 |
Forum: Data Guard «»
Posted on: Fri, 29 September 2023 14:09 «»
By: LIPEKA
Re: RMAN-00554 RMAN-04006
…. when I do that and run sql>select username, sysdba from v$pwfile_users; it returns no row selected. When I go back and recreated in as orapwSALESPRD it works fine. I believe the issue is not on the upper/lower case but somewhere else. I have …
|
| 34 |
Forum: Data Guard «»
Posted on: Thu, 28 September 2023 15:16 «»
By: LIPEKA
Re: RMAN-00554 RMAN-04006
…(c) 1982, 2019, Oracle. All rights reserved.
ERROR:
ORA-01017:[color=red] invalid username/password; logon denied[/color]
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL>…
|
| 35 |
Forum: Data Guard «»
Posted on: Thu, 28 September 2023 01:25 «»
By: LIPEKA
RMAN-00554 RMAN-04006
… from auxiliary database: ORA-01017: invalid username/password; logon denied
[rock_it_pc1@localhost dbs]$ tnsping SALESPRDSBY
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 01:56:56
Copyright (c) 1997, 2019, Oracle…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 23 August 2023 06:06 «»
By: John Watson
ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object
…editions_enabled from dba_users where username='SCOTT';
E
-
N
From the 19c Database Development guide:
So why is this throwing an error:orclz> CREATE OR REPLACE nonEDITIONABLE PROCEDURE "SCOTT"."P1" as begin
2 &…
|
| 37 |
Forum: Client Tools «»
Posted on: Sun, 23 July 2023 07:08 «»
By: Alish_999
problems with servers (tns:protocol adapter error)
… write log/pass, i have a error: "wrong username and password. Alias:crossdb" and in the folder of this program have a "sqlnet.ora" logs file and in him writing to next info…
|
| 38 |
Forum: Marketplace «»
Posted on: Tue, 30 May 2023 07:31 «»
By: Mulhmma
Re: mcoptions PAR.pm error windows 2022
…s\ADMINI~1\AppData\Local\Temp\4
TMP=C:\Users\ADMINI~1\AppData\Local\Temp\4
USERDOMAIN=MYSERVER
USERDOMAIN_ROAMINGPROFILE=MYSERVER
USERNAME=Administrateur
USERPROFILE=C:\Users\Administrateur
windir=C:\Windows
__PSLockDownPolicy=0
Regards
…
|
| 39 |
Forum: Server Administration «»
Posted on: Mon, 24 April 2023 13:10 «»
By: Michel Cadot
Re: disconnect the schema
…sid||','||serial# sid from v$session where username = dbms_assert.schema_name(p_user))
6 loop
7 execute immediate 'alter system disconnect session '''||sess.sid||''' immediate';
8 &…
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 16 March 2023 01:45 «»
By: chat2raj.s
Re: Refreshing Materialized View
…nearly 24 hrs while i tried to create a table with the same query and it is created in 45 min.
username event seconds_in_wait
CTCOFF SQL*Net message to client 0
CTCOFF db file scattered read 0…
|
Blog
Search
Help
Members
Register
Login
Home